package com.aaa.dao;

import com.aaa.entity.Forderp;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;


public interface ForderMapper extends BaseMapper<Forderp> {
    @Select("select b.name,b.head,f.id,f.price,f.num,f.zongjia,f.gtime,s.`name` namess,s.province,s.district,s.city,s.address,f.state from f_order f \n" +
            "left join book b on f.book=b.id\n" +
            "left join f_site s on f.f_site=s.id\n" +
            "where f.f_user=#{uid}  ")
    List<Map<String,Object>> find(Integer uid);
}
